-- ================================================
-- Template generated from Template Explorer using:
-- Create Procedure (New Menu).SQL
--
-- Use the Specify Values for Template Parameters 
-- command (Ctrl-Shift-M) to fill in the parameter 
-- values below.
--
-- This block of comments will not be included in
-- the definition of the procedure.
-- ================================================
USE WarehouseManagement
Go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		duylv00360
-- Create date: 
-- Description:	
-- =============================================
ALTER PROCEDURE GetSingleOrderInfo 
	-- Add the parameters for the stored procedure here
	@OrderID int = 0
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
	SELECT		o.OrderCode,
				o.OrderID,		
				e1.EmployeeID EmployeeAID,		
				e1.FullName EmployeeAName,
				e2.EmployeeID EmployeeBID,
				e2.FullName EmployeeBName,
				c.ContactID ContactID,
				c.FullName	ContactName,
				o.Date OrderDate,
				o.IsImport,
				o.IsDelete
				
	FROM [Order] o
	LEFT JOIN	Employee e1
	ON			o.EmployeeAID = e1.EmployeeID
	LEFT JOIN	Employee e2
	ON			o.EmployeeBID = e2.EmployeeID
	LEFT JOIN	Contact c
	ON			o.ContactID = c.ContactID
	WHERE		o.OrderID = @OrderID
END
GO
/*
USE WarehouseManagement
GO
EXEC GetSingleOrderInfo @orderid = 42
*/